Description:
Save an Excel file object into an Excel file.
Syntax:
f.xlswrite(xo,p)
Note:
The function saves an Excel file object to Excel file f. It is used to save data retrieved from an Excel file object in the non-@r@w method.
Parameter:
|
f |
Name of the Excel file into which data is written. |
|
xo |
An Excel object. |
|
p |
The password for accessing an Excel file. |
Example:
|
|
A |
|
|
1 |
=file("E1.xls").xlsopen() |
Read the E1.xls file and return it. |
|
2 |
=file("E2.xlsx").xlsopen() |
Read E2.xlsx and return an Excel object. |
|
3 |
=file("T2.xls").xlswrite(A1,"123") |
Write the Excel file object into T2.xlsx, and set a password, which is 123, for the latter. |
|
4 |
=file("T1.xlsx").xlswrite(A2) |
Write the Excel file object into T1.xlsx. |
|
|
|
|
|
|
|
Read data from E3.xlsx and return and Excel file object. |
|
|
=demo.query("select * from scores") |
Return a table sequence. |
|
|
=A6.xlsexport@t(A7) |
Write A7’s table sequence to E3.xlsx’s first sheet. |
|
|
=A6.xlsmove ("Sheet3") |
Delete a sheet named “Sheet3” from E3.xlsx. |
|
|
=A5.xlswrite(A6) |
Save results of the above operations on the Excel file object in A5’s Excel file. |